package org.spring.springboot.app.community.qruserinfo.dao;

import org.apache.ibatis.annotations.Param;
import org.spring.springboot.app.base.User;
import org.spring.springboot.app.community.qruserinfo.domain.po.QrUserInfoPO;
import org.spring.springboot.app.community.qruserinfo.domain.vo.QrUserInfoExcelVO;
import org.spring.springboot.app.community.qruserinfo.domain.vo.QrUserInfoSelectVO;

import java.util.List;

public interface QrUserInfoDao {
    int deleteByPrimaryKey(String id);

    int insert(QrUserInfoPO record);

    int insertSelective(QrUserInfoPO record);

    QrUserInfoPO selectByPrimaryKey(String id);

    int updateByPrimaryKeySelective(QrUserInfoPO record);

    int updateByPrimaryKey(QrUserInfoPO record);

    List<QrUserInfoSelectVO> findPage(@Param("pageNum") int pageNum, @Param("pageSize") int pageSize, String officeId, String userName, String isFill, String isLoad, String createDateBegin, String createDateEnd);
    int excSql(String sql);

    int updateOfficeBalance(String id,String money);

    int updateBySelect(String state, String officeId, String userName, String isFill, String isLoad, String createDateBegin, String createDateEnd);

    List<QrUserInfoExcelVO> findBySelect(String officeId, String userName, String isFill, String isLoad, String createDateBegin, String createDateEnd);
}